Parameter has no default value. (Error 3747)

This error occurs when using procedures. It occurs when a default value is trying to be utilized and the parameter does not have a defined default value. To prevent this error message, define a default value on the procedure, or pass in a value to the parameter.